A problem might occur when a database library is defined in SAS^® metadata and the DIRECTEXEC option is used. Even though you have Read Metadata, Read, and Write permissions set for the table, if you have the DIRECTEXEC option set and attempt to update the table using PROC SQL, the following error occurs:

For example, the problem occurs when you define an Oracle library in the metadata and you have set the following permissions for sasdemo user:

• RM on the library
• RM+R on a table from the library

For this example, the library ORALIB is registered in the above metadata server configuration. And you would submit the following code from a SAS session.

In this case, the error is returned:

The following succeeds:

As you see, with DBIDIRECTEXEC, permissions on the table are ignored.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for Base SAS 9.3_M1 is available at: